/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 11:13:26
*/


-- ----------------------------
-- Table structure for tb3531
-- ----------------------------
DROP TABLE [dbo].[tb3531]
GO
CREATE TABLE [dbo].[tb3531] (
[QuotationID] varchar(20) NOT NULL ,
[DivisionID] varchar(20) NULL ,
[TranMonth] int NULL ,
[TranYear] int NULL ,
[VoucherTypeID] varchar(20) NULL ,
[ObjectID] varchar(20) NULL ,
[EmployeeID] varchar(20) NULL ,
[CurrencyID] varchar(20) NULL ,
[ExchangeRate] money NULL ,
[QuotationNo] varchar(50) NULL ,
[QuotationDate] datetime NULL ,
[RefNo1] varchar(50) NULL ,
[RefNo2] varchar(50) NULL ,
[RefNo3] varchar(50) NULL ,
[Attention1] nvarchar(800) NULL ,
[Attention2] nvarchar(800) NULL ,
[Dear] nvarchar(250) NULL ,
[Condition] nvarchar(800) NULL ,
[SaleAmount] money NULL ,
[PurchaseAmount] money NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[Status] tinyint NOT NULL DEFAULT ((0)) ,
[OrderStatus] tinyint NOT NULL DEFAULT ((0)) ,
[IsSO] tinyint NOT NULL DEFAULT ((0)) ,
[Description] nvarchar(250) NULL ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(50) NULL ,
[InventoryTypeID] varchar(20) NULL ,
[EndDate] datetime NULL ,
[Transport] nvarchar(250) NULL ,
[DeliveryAddress] nvarchar(250) NULL ,
[PaymentID] varchar(20) NULL ,
[PaymentTermID] varchar(20) NULL ,
[Ana01ID] varchar(20) NULL ,
[Ana02ID] varchar(20) NULL ,
[Ana03ID] varchar(20) NULL ,
[SalesManID] varchar(20) NULL ,
[ClassifyID] varchar(20) NULL ,
[ObjectName] varchar(250) NULL ,
[Ana04ID] varchar(20) NULL ,
[Ana05ID] varchar(20) NULL ,
[Address] nvarchar(250) NULL ,
[ApportionID] varchar(50) NULL ,
[WarrantyNotes] nvarchar(500) NULL ,
[ContactID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb3531
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb3531
-- ----------------------------
ALTER TABLE [dbo].[tb3531] ADD PRIMARY KEY NONCLUSTERED ([QuotationID])
GO

-- ----------------------------
-- Checks structure for table tb3531
-- ----------------------------
ALTER TABLE [dbo].[tb3531] ADD CHECK (([QuotationID] IS NOT NULL AND [QuotationID]<>''))
GO
